﻿CREATE PROCEDURE [dbo].[proc_MarketProjectItem_NoSaveSumSpendingTotals]
(
	@USERID INT
)

AS
BEGIN

SELECT SUM(SpendingTotals) FROM MarketProjectItem mpi JOIN ProT_ClassT3 pct3 ON mpi.T3=pct3.id
WHERE [USERID]=@USERID AND MID=0

	SET NOCOUNT ON;


END
